Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
thanks marcus