Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
raadwiptec
Creator II
Creator II

text

I have the following below source text file similiarly for many parts until part 25 clients .. XXX are bank account numbers so put it as XXX

I want to make as below (Basically to transpose

Name | Adres | IBAN

BNP     UK        UKXXXXX

Below source files

part1

Name :BNP

Adres : "

UK"

Alias :bnp bank

Land rekening :UK

Telefoonnummer:

E-mail:

Gedeeld : Nee

Rekeningen

IBAN rekeningnummerLokaal rekeningnummerVrijBICNaam bankAdres bank

UKXX 0000 XXX XXXXXX-XXXXXX-XXXXXXBNP PARIBAS FORTIS (FORTIS BANK SA/NV)XXXX           Country

part2

Naam :BNP

Adres : "

US"

Alias :bnp bank

Land rekening :UK

Telefoonnummer:

E-mail:

Gedeeld : Nee

Rekeningen

IBAN rekeningnummerLokaal rekeningnummerVrijBICNaam bankAdres bank

UKXX 0000 XXX XXXXXX-XXXXXX-XXXXXXBNP PARIBAS FORTIS (FORTIS BANK SA/NV)XXXX           Country

1 Solution

Accepted Solutions
marcus_sommer

I think you need just to adjust this line within the very first load-statement:

if(rowno() <= 2, 1, if(left(@1,4) = 'part', peek('ID') + 1, peek('ID'))) as ID,

if(rowno() <= 2, 1, if(l@1 = 'Tegenpartij', peek('ID') + 1, peek('ID'))) as ID,

- Marcus

View solution in original post

21 Replies
beck_bakytbek
Master
Master

not clear what do you mean?

Can you give a screenshot?

Beck

raadwiptec
Creator II
Creator II
Author

My source file is a text file and it looks as below..

Below source files

part1

Name :BNP

Adres : "

UK"

Alias :bnp bank

Land rekening :UK

Telefoonnummer:

E-mail:

Gedeeld : Nee

Rekeningen

IBAN rekeningnummerLokaal rekeningnummerVrijBICNaam bankAdres bank

UKXX 0000 XXX XXXXXX-XXXXXX-XXXXXXBNP PARIBAS FORTIS (FORTIS BANK SA/NV)XXXX           Country

part2

Naam :BNP

Adres : "

US"

Alias :bnp bank

Land rekening :UK

Telefoonnummer:

E-mail:

Gedeeld : Nee

Rekeningen

IBAN rekeningnummerLokaal rekeningnummerVrijBICNaam bankAdres bank

UKXX 0000 XXX XXXXXX-XXXXXX-XXXXXXBNP PARIBAS FORTIS (FORTIS BANK SA/NV)XXXX           Country

I need the output as below

Name | Adres | IBAN

BNP     UK        UKXXXXX

BNP     US        USXXXXXX

beck_bakytbek
Master
Master

Try this:

load

Name,

Land rekening as Adres,

Left(IBAN rekeningnummerLokaal,5)  as IBAN_NR

raadwiptec
Creator II
Creator II
Author

but for IBAN rekeningnummerLokaal,? its not a column the data is one below the other

IBAN rekeningnummerLokaal rekeningnummerVrijBICNaam bankAdres bank

UKXX 0000 XXX XXXXXX-XXXXXX-XXXXXXBNP PARIBAS FORTIS (FORTIS BANK SA/NV)XXXX           Country

beck_bakytbek
Master
Master

is "IBAN rekeningnummerLokaal rekeningnummerVrijBICNaam bankAdres bank" Name of Field?

tamilarasu
Champion
Champion

Could you attach your text file here?

raadwiptec
Creator II
Creator II
Author

is it the name of the field but it just in a text file ,theree are no seperators etc.

beck_bakytbek
Master
Master

raadwiptec
Creator II
Creator II
Author

!

Hi tamil..

attached..