Discussion Board for collaboration related to QlikView App Development.
I have a single table with the following fields:
I would like to look up the name of who created each of the users. What would the load script statements look like?
LEFT JOIN (User)
The load should be from one single data source. The illustration shows the input table as table 1 and the desired output as table 2.
Try like this
UserNo & '_'& UserName As Key,
Load UserNo, UserName AS CreatedbyUserNo
Key, UserNo, UserName, ApplyMap('Map1', CreatedbyUserNo) As CreatedbyName
Drop table Table1;
UserNo as CreatedbyUserNo,
UserName as CreatedbyName
I am a fan of applymap() that Mayil Vahanan Ramasamy mentioned, so you could try this:
LOAD * INLINE [
UsewrNo, UserName, CreatebyUserNo
1, John Smith, 2
2, William Jones
3, Sally Adams, 2
4, George Doe, 3
5, Lynda Peters, 3
applymap ( 'MyMap' , CreatebyUserNo ) as CreatedByName
drop table MyData ;
Best Regards, Bill
Hi Jerry, Try with this code.