ETL Process in QlikSense

[delphinep26]

Hi ,

I have some tables like Customers , Suppliers , Products , Budget , Sales , SalesHist ...

I'm trying to do some ETL Process before modeling  ,

but I don't manage to use some basic Joins .

In example , if I need to add some column and try to join between 2 tables the original table isn't duplicated but only join between them.

The purpose was to join the tables , add the new field and remove the fields key connection .

But don't change the original table.

I need to modify the connection between tables but its seems that there are limited tools .

Some advice ?

Thanks

[jwjackso · Accepted solution]

Look at Applymap and Keep  statements.