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
not clear what do you mean?
Can you give a screenshot?
Beck
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
Try this:
load
Name,
Land rekening as Adres,
Left(IBAN rekeningnummerLokaal,5) as IBAN_NR
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
is "IBAN rekeningnummerLokaal rekeningnummerVrijBICNaam bankAdres bank" Name of Field?
Could you attach your text file here?
is it the name of the field but it just in a text file ,theree are no seperators etc.
Look at this function:
!
Hi tamil..
attached..