topic Re: code in QlikView

code

denis115 — Wed, 25 Nov 2020 16:16:04 GMT

Explain me please this part of code :

LOAD F1 as REGION,Upper(trim(PurgeChar(F1,0123456789.))) as REGION1;

Re: code

Anil_Babu_Samineni — Mon, 04 Sep 2017 14:53:35 GMT

Self Explanation is very thought to learn more information rather single line.

But, Here condition works as don't consider as 0123456789. from F1 field and which need to trim and then remaining strings need to be UPPER cases.

Condition should be this

Upper(trim(PurgeChar(F1,'0123456789.'))) as REGION1

Re: code

its_anandrjs — Mon, 04 Sep 2017 15:01:11 GMT

In the given load script part by explaining for you

1.LOAD This is load statement start part with LOAD key word.

2. F1 as REGION, THis is the field aliasing actual field name is F1 but it is renamed or Alias as REGION

3. Upper( UPPER function make Upper case to the field items

trim( TRIM function removes any spaces and trims it from all side Right and Left

PurgeChar(F1,0123456789.) PURGECHAR function not accept the numbers 0123456789 on the field and removes all this from field

)

) as REGION1; This is again renaming of the field F1.

Re: code

denis115 — Tue, 05 Sep 2017 05:20:38 GMT

thank you!

Re: code

denis115 — Tue, 05 Sep 2017 05:20:50 GMT

thank you!

Re: code

Anil_Babu_Samineni — Tue, 05 Sep 2017 06:11:09 GMT

Please flag this answer and you done assumed answer. I would ask you to goop back and flag correct answer any one of the answer so then next helpers May understood..

If you are not found, let it be..