I would like to run a job only if the number of records in the raw table it’s diferent of the number of records in the valid table wit a condition.
How can I do it?
Solved
How to use variables to usage conditions
+4Best answer by daniel
Dear rvgfox,
I've done a test for you and I hope this helps:
- Create a Project variable and set it to the table you would like to check.
- Be aware that if this table is incremental this function, the checking of raw and valid record is equal, will not work because the raw table will contain only the newly loaded records
- Create a new execution package and put in the tables you want to reload if the condition is right (or not)
- Put in the project variable in the Usage condition
Hope this helps!
Take care
= Daniel
+7Dear rvgfox,
I've done a test for you and I hope this helps:
- Create a Project variable and set it to the table you would like to check.
- Be aware that if this table is incremental this function, the checking of raw and valid record is equal, will not work because the raw table will contain only the newly loaded records
- Create a new execution package and put in the tables you want to reload if the condition is right (or not)
- Put in the project variable in the Usage condition
Hope this helps!
Take care
= Daniel
+4Thank you very much Daniel,
But, in your example the raw table has values from the previous execution because the raw table it’s filled in the same job, isn’t it?
+7I ran a full load on that table so in that case the Raw and the valid table should have the same rowcount because it hase ran in 1 run. The raw table cannot have row from a previous execution and the valid table not I believe.
+7It might be useful to know the use case you are trying to achieve, as there may be a different solution entirely.
You could make separate execution packages for ODX (or other layer) transfer and Data Cleansing Rules for the tables you want and apply variable-driven conditions to the latter.
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
