source

[raadwiptec]

hi all,

I get data from a static source like erp kind application and finally we recieve the source as a flat file ex.txt. these static files are uploaded in QV..

but my requirement is few columns of these data needs to be updated or changed sometimes. I Will not be able to go back to my source.

any other ideas here. For example using an excel i could edit the values in QV

[its_anandrjs]

Can you explain with an example for this issue or may be you can go with the Incremental load for this.

Regards,

Anand

[avinashelite]

could you please share the sample data and what changes you need to make ?? so it will be helpful for us to suggest the solution

[MindaugasBacius]

Remove, insert columns or make any other changes not in ex.txt but while loading the data in the QlikView.

[syukyo_zhu]

Hi,

I don"t know how do you charge yours file txt in qlik, do you have a file per day or per week, do you have charge severals file or juste a single file.

Why don't you backup your file txt in the end of your script everyday. So if you need change value for some fields, you can modify your file txt backuped and recharge your data from these files modified.

Hope helpful.

[raadwiptec]

I am looking for some kind of logic that can be implemented.

My Source is for ex Data.txt  ----> This file gets uploaded into QV

----------> In QVi created a pivot chart.

For ex Data will be as below

Customer ¦ Transactions ¦ Amount ¦ References

10000121 ¦ 54656454545646 ¦ 23000.22 ¦ XFD656565

10000123 ¦ 54222233396646 ¦ 4523000.22 ¦ XFD656323

10000127 ¦ 58787899999946 ¦ 823000.22 ¦ XFD6565454

10000128 ¦ 54656548222246 ¦ 283000.22 ¦ XFD6564545

so here i need to edit certain values for References without touching data.txt file.
I will not be able to edit anything in the Data.txt going back also

[syukyo_zhu]

Do you try to use a correlation table,

For example, your need change reference from XFD656565 to XFD656777 for today

28042016|XFD656565  --->  28042016|XFD656777

Then you can use mapping/applymap to change your value in table target.

[raadwiptec]

hi xia, can you give me more detail here..how to make correction table and how to link?

[syukyo_zhu]

Sorry, i don't find here how can i attach file.

//if you want to change reference XFD656565 to XFD657777 juste for today and for all of your data

MappingSource:

mapping LOAD * INLINE [

Source, target

29042016|XFD656565,XFD657777

];

//if you want, you add id client or others informations in mappingsource, par example 29042016|10000121|XFD656565

//you can use inline or file excel

//then you can use applymap to change your value

Source:

load

     Customer,

     Transactions,

     Amount,

     applymap( 'MappingSource', Date(Today(), 'DDMMYYYY')&'|'&References,  References) as References;

LOAD Customer,

     Transactions,

     Amount,

     References

FROM

[.....\source.txt]

(txt, codepage is 1252, embedded labels, delimiter is ' ', msq);

[arasantorule]

Hi,

I am thinking this way

If you know the definite list of values and their respective reference values, we can maintain them in an excel file.

Now ,Load the raw data from .txt or any file.

Load data from excel file with reference values.

Now use the applymap() function to add,edit,update or concatenation to the actual value.

Thanks.