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?

I created a dataset using PostgreSQL yesterday. I used three tables while creating it, but I just realized I forgot to add a table. Is there a way to add a new table to an existing dataset?

I created some datasets using MySQL today. I usually apply the truncate and load refresh types during the Alter dataset. I see that the delete-insert option is present too. Can someone please explain what it does?

I am creating datasets using SQL Server in Lumenore Connect and noticed an option to enable Change Data Capture (CDC). After enabling it, I did not observe any visible changes. Could you explain what Change Data Capture is, and how it works?

I have a column in my Excel. I cannot update the column name as the file is too large to open on the system. Is there a way to update the name using the Excel connector before data loading?