okay thanks, but that further down the road... looking for help in configuring the rules based schema and maybe some examples using my criteria above.

Thanks.

10-15 rules at this point...yes we would like a UI for BEU to make changes to the different rules..

Have any good examples of how to accomplish based on requirements provided?

Thanks...

Rather than having to hard-code all of these rules in SP thats why I was thinking using this rules table.

The Channel,ShipFrom, and Prodline all exist in the unnamed table(Update table).

The rules table would be used in logic like:

If Channel = ???

and shipfrom = ???  Could be single entry, or...

Is there some magic that pulls in the file?

Thx.

• This reply was modified 3 years, 5 months ago by Bruin.

Thats Cool.. just like I was thinking output should look.

Yeah the dynamic exclude is big piece..

Your retiring no way man!!!

Many thanks..

Jeff,

Thanks for update, and yes each data record could contain ALL of the tags I'm looking for, or maybe just 3-4 of them there is no set

data record that ends...

Would you be able to show me in script where to put this logic in to filter by tags and the SQL Insert?

Many Thanks..

I tried using one example, but it isn't doing the filtering against array from your script.

$qyarray1 = @("insert_job")

Any help much appriacted trying to just filter on Tags needed.

Thanks.

So I was thinking of doing something like:

$qyarray1 = @("insert_job")

Putting all of the tags I want to capture from the file extraction then inserting a condition based lookup and load...

that's what I stumped with how to introduce that in script. I found that 2 tags Command and Description only on some records

are causing the issue with full file.

How could I put the ones I want in an array then only select them?

Sorry maybe what I'm asking is if your original script could only find tags listed rather than reading entire record set.

When I did some samples it maybe running into an...

How could original script posted by zzartin, be modified to just pickup these tags during extraction? Currently it's finding ALL which do some testing with the file might be the...