Merging Fields from two different Tables in a New Table

[ujji]

Hello Qlik Experts,

I have a Query which i have apparently explained in the attached file (Excel).It would be a great help if one can assist me with it.

Thanks in advance.

[Clement15]

Hello

Have you tried using the Concatenate function?

Concatenate | Qlik Sense on Windows Help

[theoat]

Good afternoon,

To do this, you can use the script.
Note that I put a table per sheet.
Then we concatenate the tables of each branch (making sure to put the same field names, and creating a field "branch" not to lose information).
Thus, we get to have the expected table.

Sincerely,
Théo ATRAGIE.

[icemachine29]

I have two tables with similar information. Let's call them items_a and items_b. They should be one, but they are coming from different sources, so they aren't. When I full-join the two table, some rows end up with data from either one or both tables. One of the columns in both tables is category_id. I would like to cross the combined table with the categories table using category_id.

[theoat]

Good morning,

Can you show an example of what do you want ?