search and map data

[#1]

Hello, i'm sure you can help me with this.

i've got a loadscript with some tables - lets call them "Sales" and "Customer". In Customer the Key-Field is No_.

Now i'd like to search for the min([Posting Date]) of every Customer.No_ in the Sales-Table. The found result should be added to the Customer-Table, the name of the field is "[first bought]"

can you explain me how this works in the loadscript?

Thank you!

Best,

Tim

[sujeetsingh · Accepted solution]

Just Resident load  temp table and derieve the minumum() of the field.

Now you can easily map the minimum based on the valid Key in your data model,

by using Applymap() oe Left Join()