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: 
Booboojones
Contributor
Contributor

Creating a calculated field off a joined table

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!

2 Replies
jwjackso
Specialist III
Specialist III

Try renaming the [Entity] as [Dept]

[Providers]:
LOAD
[Provider],
[Dept]
FROM [lib://list.xlsx]
(ooxml, embedded labels, table is [Providers]);

[Charges Export]:
Right join LOAD
[Provider],
[Entity] as [Dept],
[Charges]
FROM [lib://Charges.xlsx]

(ooxml, embedded labels, header is 2 lines, table is [Charges Export]);
Booboojones
Contributor
Contributor
Author

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!