Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Hariprasad
Contributor II
Contributor II

How to add comment in inline load

Hi All,

I want to  add comment in line load statement, will it work comment in line load?

example

Load * inline [

customer, sales

hari, 20000
 krishna, 3000 
];

exit script;

Labels (1)
1 Solution

Accepted Solutions
Hariprasad
Contributor II
Contributor II
Author

Thanks for your quick help. comment is working inline 

for section access when i try to run all scenario's with different user's getting wrong vales, if i comment 1 by 1 it will work.

as per requirement all scenario's should work with different user's with right vales. 


INLINE

[
ACCESS, USERID, WMC, VEH_MODEL_SERIES_CD

 ADMIN, EMEA\hel, 3MX , *

USER, EMEA\fwin, 3MX , 177
ADMIN, EMEA\nkgu,* , 177
ADMIN, EMEA\boe, * , 177|207
ADMIN, EMEA\aha,* , *

](txt, comment is '//');


section Application;

View solution in original post

9 Replies
rui24
Creator
Creator

Need to be

"Name of the table you want creat or upload into":

Load * inline [

customer, sales

hari, 20000
 krishna, 3000 
];

If it's not this please check this video, i think will solve your problem

https://www.youtube.com/watch?v=ikoNWLhfaYs

Bhuvi
Partner - Contributor III
Partner - Contributor III

Try this

comment Table tablename With 'Comment';

Saurabh_K14999
Contributor III
Contributor III

Hi,

//Comment

Load * inline [

customer, sales

hari, 20000
 krishna, 3000 
];

exit script;

You can add comment this way in the inline.

Regards,

SK

Hariprasad
Contributor II
Contributor II
Author

Thanks for your quick response.

But i want comment row in inline table , please find the below scenario, i commented in 2nd row, but out i can see 2 rows

Hariprasad_0-1671705776286.png

Hariprasad_1-1671705878869.png

 

 

 

Hariprasad
Contributor II
Contributor II
Author

 

Hariprasad_2-1671706409537.png

 

rui24
Creator
Creator

I have a simple and fast solution to you 

------------------------------------------------------------------------------------

-TABLE UPDATE WHAT YOU WANT TO USE-

T1:

Load * Inline[

customer, sales

hari, 20000

];

------------------------------------------------------------------------------------

PLUS

------------------------------------------------------------------------------------

-TABLE ORIGINAL ALL COMMENT TO SEE MODIFICATIONS-

// T1:

// Load * Inline[

// customer, sales

// hari, 20000,

// krishna, 3000 

// ];

------------------------------------------------------------------------------------

ITS NOT THE PERFECT SOLUTION, BUT WORKS, AND IF YOU FORGET SOMETHING YOU HAVE THE ORIGINAL BELOW COMMENTED

 

 

 

Hariprasad
Contributor II
Contributor II
Author

Hariprasad_3-1671710236557.png

 

marcus_sommer

An inline-load is the same like loading any txt-file. This means a file-format statement and also each kind of a where-clause could be used and so you could include comments within the content, for example with something like:

load * inline [
F1, F2
a, 1
//b, 2
*c, 3] (txt, comment is '//')
where left(F1, 1) <> '*';

- Marcus

Hariprasad
Contributor II
Contributor II
Author

Thanks for your quick help. comment is working inline 

for section access when i try to run all scenario's with different user's getting wrong vales, if i comment 1 by 1 it will work.

as per requirement all scenario's should work with different user's with right vales. 


INLINE

[
ACCESS, USERID, WMC, VEH_MODEL_SERIES_CD

 ADMIN, EMEA\hel, 3MX , *

USER, EMEA\fwin, 3MX , 177
ADMIN, EMEA\nkgu,* , 177
ADMIN, EMEA\boe, * , 177|207
ADMIN, EMEA\aha,* , *

](txt, comment is '//');


section Application;