Suggest an Idea

[guidog]

First of all, pardon my english.... I'm using Qlik Data Transfer to load data from SAP B1, but there are two couples of tables named "OINV & ORIN" and  "INV1 & RIN1", that seems they have the same structure and fields; so when I execute the Charge function for the Data Conexion, I don't see the ORIN and RIN1 tables on my SaaS Space, instead after review Charge Details, I see this:

OINV << ORIN

INV1 << RIN1

It was a Concatenation?

Can't avoid this function?   

[Ian_Crosland]

Hi

You could add NoConcatenate to your script:

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes...

and use the Data Gateway Direct Access tool:

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Gateways/direct-access-g...

Thanks

Iam

[guidog]

Thanks Ian for your recommendation, unfortunately Qlik Data Transfer does not allow you to modify the Script it generates for data extraction, it only allows you to select the fields of a source table at a time and optionally filter records. The way to avoid concatenation is to force them not to have exactly the same structure, discarding fields from any of the tables.

Thanks again...

[Ian_Crosland]

Hi

Yes the recommendation was to use the Data Gateway Access tool not Qlik Data Transfer for this use case

Thanks

Ian