Multi-database join works in enterprise automation, but fails in integration builder. 追蹤
I have an issue where i have a csv file with 7 rows in it, 2 of the 3 rows change per row, 1 is the same as it is a bundle # that spans all 7. I setup in the enterprise automation a multi database join, 1 that grabs all 7 entries in their entirety, the other selects the top 1 row of the csv file, i had to join them so i joined them on the bundle #, all prints just fine in enterprise automation, it prints the 1st label as the bundle label, and each of the 7 labels for all items in the csv. (the reason i had to do this is if i used it all as one database it would print 7 bundle labels as there were 7 rows of it, i just needed the one).
Putting it into an integration that polls a file location and prints the contents of csvs in that folder, i used an existing integration that works fine without a multi-database join in it. cloned it, added this label file, and it will print as long as the csv contents match the example file used in the label file. If i use a new csv with a new bundle #, i get a no records found.
All i can surmise is that the integration isn't passing the csv to the label file such that it handles the multi-database join properly, its trying to join the file that was polled, and the example file, and since its an inner join, it comes up with no records. I have no idea how to fix this though, has anyone had this issue before?