topic Re: Change Field Data Type Dynamically in QlikView

Change Field Data Type Dynamically

Tiwalade_Omotosho — Fri, 15 Nov 2024 23:57:26 GMT

Hi,

I am currently working on a Script. I am dynamically loading CSV Tables into QlikView from a list. Each field can contain Hundreds of Fields.

However, after transforming using crosstables, some text values were converted into numbers. For example "1 7". "1 6" which is a text was converted into 17 and 16 respectively. After running a simulation using one of the affected fields, I discovered that this did not happen if I explicitly loaded the field as Text (Text(-----)).

How can I change the Data Type for each field at the point of loading and still retain the name of the field.

@swuehl @sunny_talwar @hic @jagan

Re: Change Field Data Type Dynamically

swuehl — Tue, 22 Sep 2020 08:19:17 GMT

Control of the "data type" in the LOAD script is very limited in QlikView.

Would be good to actually see your script (best using small sample script and data set) to be able to tell you more.

Re: Change Field Data Type Dynamically

Tiwalade_Omotosho — Tue, 22 Sep 2020 09:02:59 GMT

Thanks a Lot for responding. I was able to figure out a work around

Since I was loading from what is already stored in QVD,

1. I did an extra-transformation on the extraction script to generate the field statements where the text function has already been applied.

2. I concatenated the different fields to generate the modified load statements per QVD

3. I then loaded this using a loop into the Transformation script.