Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI Community,
I need one clarification..
I have 2 same table structure,
First table master table and second table depending on 1st table based on Policy ..
i want compare with only Policy Id. i want to give left join only
and remaining fields should be concatenate with both tables.
i don't want to rename second tables names....
Emp:
LOAD Country,
Location,
Client,
[Policy],
Employee,
Currency,
Month,
Year
FROM
Left Join
Cust:
LOAD Country,
Location,
Client,
[Policy],
Employee,
Currency,
Month,
Year
FROM
(qvd);
Hope you understand...
Thanks in Advance..........
Hi,
Without renaming its not possible.
Better if you post sample data with expected output.
Regards,
Hi,
Please post sample app
Regards,
Nadeem
Hi Paul,
You can try the other way use EXIST condition in the second table using policy ID so it will load only the Policy id which is present in the 1 master table and it con-cat automatically
You can try adding Table resp. flags to identify data and then play around in the script.
Try something like:
Emp:
LOAD Country,
Location,
Client,
[Policy],
Employee,
Currency,
Month,
Year,
'From Master' as TableFlag
FROM
Concatenate
Cust:
LOAD Country,
Location,
Client,
[Policy],
Employee,
Currency,
Month,
Year,
'From Employee' as TableFlag
FROM
(qvd);
Hope this answered you query or was helpful.
Thanks,
Singh
Hi,
Avinash is correct I guess this should solve it .
Regards,
Nadeem