Store command qvd not working qliksesne

[Aspiring_Developer]

Hello ,

I am facing very strange issue while storing txt file in qliksense:

I have below connection:-

Now i writing the store syntax like this:-

Store Users into [lib://Site HR (ad_admin.kkishor)/HR Divisions Scorecard/Security/Users_New.txt](txt);

I have entered my connection name as well but still the txt file  is not created at the location. I am not able to understand what i am missing . Can any one please help ?

@Anil_Babu_Samineni @sunny_talwar @Gysbert_Wassenaar @p_verkooijen 

Thanks in advance

[canerkan]

Hi,

ist it possible that you just forgot to undo the commentary. I quoted your script part and marked the part i meant in red. You werde loading with Residet Users but did not drop it before you renamed your Table "User_Final". I'm not sure but this might be a reason for an error as you already have a Table called Users. So it does not get to the line where it stores your Table.

---

User_Final:
Load
upper(NTNAME) as NTNAME,
All_SITE.REFERENCE as SITE.REFERENCE,
upper(All_SITE.REFERENCE) as UPPERSITE,
upper(GROUPE.REFERENCE) as GROUPE.REFERENCE,
upper(ACCESS) as ACCESS,
upper(COMPAGNIE.REFERENCE) as COMPAGNIE.REFERENCE,
upper(DIVISION.REFERENCE) as DIVISION.REFERENCE,
upper(BU.REFERENCE) as BU.REFERENCE,
upper(REGROUPEMENT.REFERENCE) as REGROUPEMENT.REFERENCE,
upper(PERIMETER) as PERIMETER
resident Users;
//drop table Users;

rename Table User_Final to Users;

Store Users into [Y:\POG_Sources_Documents\HR Divisions Scorecard\Security\Users_QVTEST.txt](txt);

---

[Ksrinivasan]

Hi,

Your Table Name is User_Final, but you have used to store as Users,

In store Code you have not mention Table name : User_Final, wrongly entered Table Name :Users, So file  wont create 

Store Users into [lib://DeleteVB (ad_admin.kkishor)/Users_New.csv](txt);

[Aspiring_Developer]

Hello @Ksrinivasan 

I have renamed the renamed the table User_Final to Users , post that storing it into txt file.

[Ksrinivasan]

hi,

Just do it,

1.  Create one txt file name like Test_01.txt in path
[Y:\POG_Sources_Documents\HR Divisions Scorecard\Security\

2. Create new app

3. Load Test_01 text file (now it give you proper path)

4. copy the loading file path and write store code with copy the loading file path and paste it.

5. now run and check your folder, your will be there.