if field is populated then....
Not sure if this is possible...
I currently have a Flow that uses meta checks.. if there is a file present it goes one way, if its not there, it goes another way...
a lot of the "file present" flow section is very similar to the no file... so I'd like to see if there is a way to do this differently.
for example:
No file, loads 1 file, then processes it..
File present adds that file in, then xrefs it to filter only the data present in the 2nd file.
is there a way to do a check, then only load and xref if that file is there?
only run the "green lines" if the other file is there...
***EDIT***
I think I can use the meta check.. if the field with the other file is present, continue...just a pain to have to use 2 meta checks for each split..
it would be nice though, if there was a "Conditional Path" Node.. If A then path 1, If B then Path 2, If C then path 3... etc
Attached files
-
If I understand the above right, you want the Aggregate node to run on either:
1. There's no new file found today, so we will just process a common file we have saved somewhere.
2. There is a file found today, therefore we want the new records in it that are not in the common file, i.e. the difference between the files.
I made attempt at doing this without a metacheck, it could be debated which method is preferred.
1. The data flow will read in CommonFile.xlsx regardless of anything.
2. The data flow will try to find TodaysFile.xlsx, maybe it exists maybe not.
3. We will figure if step 2 is true or false (Transform node: Figure out which file to use).
4. If step 3 is true, we'll keep the data from step 1 (Lookup node: Only have values when TodaysFile is found).
5. If step 3 is false we drop all the data from step 1 (Lookup node: Only have values when TodaysFile is found).
6. If step 3 is true we will also read TodaysFile.xslx (Excel node: Process Either Generic File or Todays File)
7. If step 3 is false we will process a second time CommonFile.xlsx (Excel node: Process Either Generic File or Todays File). Remember in this scenario we have 0 records coming out of our CommonFile.xlsx Excel node that will always run.
8. We merge the data on whatever our common fields are.
9. The left orphans of the merge will now always contain either all of the CommonFile.xlsx data or the difference between CommonFile.xlsx and TodaysFile.xlsx.
10. Perform next step of the logic that is common to both paths (Aggregate node: This input will have all the GenericFile Records OR updates between GenericFile vs TodaysFile).
Hope that helps.
Attached files
Please sign in to leave a comment.
Comments
2 comments