Which browser is better?Ajax or IE?

[d_koti24]

Hi ,

            Which browser is better?Ajax or IE?

Thanks,

koti

[nikhilgarg]

Hey,

I think you need to do Data transformation. While loading data click on data transformation and then click on Garbage option. There you have to delete first 20 rows . I think you need range option for this.

Thanks

[jagan]

Hi,

Try like this

1. Put a where condition like

LOAD

*

FROM DataSource

WHERE Len(KeyField) > 0;

2. You need atleast a key filed to identify new records, and you can exists() in where condition.

Regards,

Jagan.

[engishfaque]

Dear Koti,

You need to load data in the same way as you do.

QlikView automatically load those values which exist in the source, and null values will not be loaded.

Kind regards,

Ishfaque Ahmed

[tobias_klett]

Hi Koti,

1. Do you mean the Column Names appear in line 21? Then load using this statement:

FROM
[YourFile.xlsx]
(ooxml, embedded labels, header is 1 lines, table is Table1);

2. Which field is to be loaded incremental?

Regards Tobias