ETL Process in QlikSense

delphinep26 — Mon, 02 Mar 2020 13:21:52 GMT

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

Re: ETL Process in QlikSense

jwjackso — Mon, 02 Mar 2020 15:24:11 GMT

Look at Applymap and Keep statements.