aleung
Contributor III
Joined 9 years ago
User Profile
User Widgets
Contributions
Re: Data reconciliation solutions?
What would be the issue if you use SystemModStamp as your state. e.g. Assuming Data Warehouse is one of the consumer Data Warehouse : select Max(SystemModStamp) > SFDC > REST SOQL where SystemModStamp > $SystemModStamp via SL > Kafka Producer > Data Warehouse1.7KViews0likes1CommentSnapGPT Wishlist
Auto mapped with mapping expression by providing sample input and expected output. Inline mapping expression suggestion based on natural language prompt Auto suggest a collection of snaps based on natural language prompt (Read Transcript data from Cornerstone Transcript)1.6KViews0likes0CommentsRe: Extract transaction sets from text data
aaronb: nt is coming in as just a text file which I am then parsing using a CSV delimiter snap with “*” as the delimiter in this case. The issue I run into is that in the file each ST to SE block of data needs to be kept together as it contains invoice header and invoice detail data. The only context of what invoice line detail goes with which header is that they both reside in the same ST to SE block. Hopefully that makes sense or helps clarify. EDI data usually required a purpose build parser. You either likely need to write a custom python script to group it by ST/SE or some 3rd party solution to get it to a XML or JSON form before feeding it to snapLogic2.5KViews0likes0Comments