Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
we are getting the following issue while using Section access. the data is as follows.
we are appliying access on the CODE Field and CODE 1 Field.
in this case we are not getting the data related to CODE 103 and 104 if we kept blank in the Inline load.
load * inline [
Access,NTNAME,CODE,CODE 1
ADMIN,XYZ,100,200
USER,PQR,100,300
USER,EFG,103,
USER,STU,104,
];
CODE | CODE 1 |
100 | 200 |
100 | 300 |
100 | 400 |
101 | 500 |
101 | 600 |
102 | 700 |
102 | 800 |
103 | |
104 | |
105 |
Please Suggest.
-Nilesh
Try putting a * in the code 1 column for 103, 104, 105
Bill
No its not working
also one more thing these two fields are not related in the Data model.
Please suggest.
-Nilesh
Nilesh could you provide us with more detail on your data model? Could you send a picture of the structure?
Hi. Maybe you can try this.
Put * like Bill told, but put the line
start is *;
before the section access.
Alessandro Furtado
Add this before the section access script;
star is *;
then use * for columns 103, 104 and 105