Forum Discussion

darshthakkar's avatar
darshthakkar
Valued Contributor
4 years ago
Solved

Ingesting dynamic values in XML generator snap

I’ve 10+ columns which needs to go inside an XML generator snap; out of which, there is 1 column which has none to single to multiple values. For each of these records, how can I dynamically pass it ...
dwhansen-cbg's avatar
dwhansen-cbg
Contributor
6 years ago
Copy LinkReport

For anyone wondering, I’m using a Join Snap with an Outer Join.

If a unique ID field from the left side is null but populated on the right side then it is a deleted record.
If a unique ID field from the left side is populated but null on the right side then it is a new record.
If a unique ID field from the left side and right side are both populated then the it is an existing record.