RE: Keepchar

[Chanty4u]

Hi all,

I want to load multiple excel files from one folder .

ref: RE:Multi load with names

AS folder names like below

'YYYYMM'

ss201601

ab201602

cc201603

dd201604

now i want to load with only date as new column into qlikview

i used below code but its not working?

how to load only  date from the filename?

Multi:

LOAD Account,

credit,

debit,

open,

Date(Date#(keepchar(FileBaseName(),'YYYYMM'),'YYYYMM'),'123456789') AS Date

FROM

(ooxml, embedded labels, table is Sheet1);

[Chanty4u]

for clever  exp it giving me the result as below bro

[sunny_talwar]

So is this taking you in the right direction? I know you mentioned that my approach gave you ####, but this definitely looks like an improvement

[Clever_Anjos]

As I´m not using the MonthStart just to make sure that would be 1st.

[Chanty4u]

yes sunny ... your exp is giving ### .. clever exp working fine.

[sunny_talwar]

Sounds good, I am not sure why it would be doing that, but as long as you get what you wanted, its all good