Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

search and map data

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

1 Solution

Accepted Solutions
sujeetsingh
Master III
Master III

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()

View solution in original post

1 Reply
sujeetsingh
Master III
Master III

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()