How to add comment in inline load

[Hariprasad]

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;

[rui24]

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]

Try this

comment Table tablename With 'Comment';

[Saurabh_K14999]

Hi,

//Comment

Load * inline [

customer, sales

hari, 20000
 krishna, 3000 
];

exit script;

You can add comment this way in the inline.

Regards,

SK

[Hariprasad]

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]

[rui24]

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]

[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 · Accepted solution]

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;