My file contains many string columns. The issue is that the data appears in different cases, such as uppercase, lowercase, and title case. I want to standardize the data so that all values follow a single consistent case throughout the file. How can I achieve this?

My CSV file has two columns containing the customers’ first and last names. How can I create a new column that contains the full name?

My Excel file contains some null values in the various columns. How can I assign some fixed value to these nulls?

I have an Excel file. When I preview my Data, it is accurate, but it contains some columns with null values. They are customers who did not complete their registration. I want all entries removed where even a single column is null. Can I achieve that via Lumenore Connect?

I am using the Excel connector. I have three sheets in my file. I preview my data, and it is correct. I now want to apply some filtering to my data. Can someone tell me how I can do so?

I have created quite a few Datasets in Lumenore Connect using multiple connectors.
I can see multiple options when I try to use the Alter date option. Can someone please explain what functionality each one provides?