Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I am joining two tables and attempting to create a calculated field that would be a combination of one field from each table, but after having researched solutions on the community, I am still not able to return my desired results.
Here is the gist of my current script -
[Providers]: LOAD [Provider], [Dept] FROM [lib://list.xlsx] (ooxml, embedded labels, table is [Providers]); [Charges Export]: Right join LOAD [Provider],
[Entity],
[Charges] FROM [lib://Charges.xlsx] (ooxml, embedded labels, header is 2 lines, table is [Charges Export]);
The two tables join on the provider field. Now that I have the tables joined, I want to combine the Entity field from the Charges Export with the Dept field from the Providers table, but am unsure as of how to do this in Qlik syntax.
Any insight is appreciated.
Thanks!
Hi Jwjackso, thanks for the response. The [Entity] and [Dept] fields are separate sets of data with no overlap, so when I renamed [Entity] as [Dept] this essentially made a union of those fields. I would instead like to combine the two fields as [Entity]&[Dept] in a combined field while retaining both the [Entity] and [Dept] fields separately in the table.
Do you know how I do this? Do I have to create some sort of third resident load?
Thanks!