Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Booboojones
New 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
Valued Contributor

Re: Creating a calculated field off a joined table

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
New Contributor

Re: Creating a calculated field off a joined table

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!